2014-10-10 - 14844.100 -SPEC-MENLO material job running longer #ABAPEXTRACT
SPECIFICATIONS
14844-Spec-MENLO Material Job Running Longer
Purpose
Menlo Material Extract Job Running Longer
Admin Info
Purpose
|
Performance Tuning of Menlo Material Extract Job
|
Requested By
|
Rahul Attarde
|
Spec Created By
|
Venkat Kondapally
|
Spec Created Date
|
10/10/2014
|
Spec QA by
|
Venkat Kodapally
|
Objects
|
ZRMM_MTL_CHGS_EXT
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
|
3
|
Development/ Config
|
|
4
|
Unit test in DEV
|
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
The Menlo Extract Job is running longer. We are adding a one day delay to sending our material partmaster files to Menlo.
The SAP job to create them is running past the job in EDI that sends them…
The process in SAP kicks off 9 pm and is now running anywhere from 5 to 8 hours. The EDI job to send them is at 11:30 pm.
In the current state, materials created on day 1 (before 9 pm) will not be transmitted until 11:30 pm on day 2. Not sure how much impact there is to the business, but I know we’ve always communicated that materials have a 24 turn-around at Menlo and now this is not the case. If the job running a long time is unavoidable - we can look at rescheduling either or both of the jobs involved.
Analyze the Jobs and recommend If we can improve the Performance.
In Scope:
[List the
activities to be included in scope]
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Job Name: NA_MM_MATERIAL_CREATE_CHNG_MENLO
Programs:
1)ZRMM_MTL_CHGS_EXT
2)ZRMM_MTL_PLANT_EXT
We Modified the Program ZRMM_MTL_CHGS_EXT to remove the logic which is longer used and by changing the logic in some places to fetch data from database to improve performance.
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
|
|
|
Solution Details
[Provide complete technical details for configuration or programming here]
Job Name: NA_MM_MATERIAL_CREATE_CHNG_MENLO
Programs:
1)ZRMM_MTL_CHGS_EXT
2)ZRMM_MTL_PLANT_EXT
The Job has Four Steps, the First step was running longer followed by second step. Both one and two steps is same program with different variants. After analyzing the program ZRMM_MTL_CHGS_EXT , we found some logic like Logs which were in use previously but are no longer in use. After discussing with NEC we decided to eliminate unwanted logic as it was causing performance problems.
We Modified the Program ZRMM_MTL_CHGS_EXT to remove the logic which is no longer used.Logic in some places was changed to fetch data from database tables to improve performance.
Issues
[List Issues / Bugs identified in configuration or development]